package org.jeecg.modules.demo.sopayorder.mapper;

import com.baomidou.mybatisplus.core.conditions.Wrapper;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import org.apache.ibatis.annotations.Param;
import org.jeecg.modules.demo.sopayorder.entity.SoPayorder;
import org.jeecg.modules.demo.utils.MybatisPlusConst;

import java.util.List;
import java.util.Map;

/**
 * @Description: so_payorder
 * @Author: jeecg-boot
 * @Date:   2021-12-18
 * @Version: V1.0
 */
public interface SoPayorderMapper extends BaseMapper<SoPayorder> {
    public String getMaxCode();

    public List<String> selectByPuiNo(@Param("puiNo") String puiNo);

    public SoPayorder getBySopNo(@Param("no") String no);

    public SoPayorder getByPuiNo(@Param("no") String no);

    public double getSumJe(@Param("no")String no);

    public double getQCyfSumJe(@Param("no")String no);

    public List<SoPayorder> getListByPuiNo(@Param("num") String num);

    public Map<String,Double> getNumAndMoney();

    public Map<String,Double> getSktOrderNumAndMoney();

    List<SoPayorder> getListByYfOrder(@Param("str") String str);

    List<SoPayorder> getByQcyfOrder(@Param("str") String str);

    IPage<SoPayorder> getPageList(Page page, @Param(MybatisPlusConst.QUERYWRAPPER) Wrapper<SoPayorder> queryWrapper);

}
